| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
Id |
|
INTEGER |
NO |
|
StudentAwardId |
|
INTEGER |
NO |
|
| DirectLoanIdentifier |
|
CHAR(21) |
YES |
|
| SchoolDirectLoanCode |
|
CHAR(6) |
YES |
|
| borrowerssn |
|
CHAR(16) |
YES |
|
| borrowerlastname |
|
CHAR(16) |
YES |
|
| borrowerfirstname |
|
CHAR(9) |
YES |
|
| borrowermi |
|
CHAR(1) |
YES |
|
| borrowercity |
|
CHAR(16) |
YES |
|
| borrowerstate |
|
CHAR(2) |
YES |
|
| BorrowerPostalCode |
|
CHAR(14) |
YES |
|
| BorrowerLocalStreetAddress |
|
TEXT |
YES |
|
| borrowerlocalcity |
|
CHAR(16) |
YES |
|
| borrowerlocalstate |
|
CHAR(2) |
YES |
|
| BorrowerLocalPostalCode |
|
CHAR(10) |
YES |
|
| BorrowerPhoneNumber |
|
CHAR(16) |
YES |
|
| borrowerdriverlicensenumber |
|
CHAR(20) |
YES |
|
| borrowerdriverlicensestate |
|
CHAR(2) |
YES |
|
| BorrowerBirthDate |
|
DATETIME |
YES |
|
| borrowercitizenstatus |
|
CHAR(1) |
YES |
|
| BorrowerAlienIdentifier |
|
CHAR(9) |
YES |
|
| borrowerdefaultonloans |
|
CHAR(1) |
YES |
|
| borroweremployer |
|
CHAR(30) |
YES |
|
| BorrowerEmployerStreetAddress |
|
CHAR(35) |
YES |
|
| borroweremployercity |
|
CHAR(20) |
YES |
|
| borroweremployerstate |
|
CHAR(2) |
YES |
|
| BorrowerEmployerPostalCode |
|
CHAR(10) |
YES |
|
| BorrowerEmployerPhoneNumber |
|
CHAR(16) |
YES |
|
| BorrowerLengthAtEmployer |
|
NUMERIC(18, 2) |
YES |
|
| loanamountapproved |
|
MONEY(19, 4) |
YES |
|
| loanamountrequested |
|
MONEY(19, 4) |
YES |
|
| OriginationBatchIdentifier |
|
VARCHAR(30) |
YES |
|
| originationstatus |
|
CHAR(1) |
YES |
|
| originationdate |
|
DATETIME |
YES |
|
| OriginationLastExportedDate |
|
DATETIME |
YES |
|
| acknowledgedate |
|
DATETIME |
YES |
|
| unsubeligibilityflag |
|
CHAR(1) |
YES |
|
| unsubeligibilityuptoheal |
|
CHAR(1) |
YES |
|
| bookstatus |
|
CHAR(1) |
YES |
|
| bookdate |
|
DATETIME |
YES |
|
| PromNotePrintIndicator |
|
CHAR(1) |
YES |
|
| PromNoteSignedByStudent |
|
CHAR(1) |
YES |
|
| PromNoteSignedByBorrower |
|
CHAR(1) |
YES |
|
| PromNoteReceivedSignedDate |
|
DATETIME |
YES |
|
| PromNoteAlteredByBorrower |
|
CHAR(1) |
YES |
|
| PromNoteStatus |
|
CHAR(1) |
YES |
|
| PromNotePrintedDate |
|
DATETIME |
YES |
|
| PromNoteSignedDate |
|
DATETIME |
YES |
|
| PromNotePrintSequenceNumber |
|
INTEGER |
YES |
|
| PromNoteAcceptedAmount |
|
INTEGER |
YES |
|
| PromNoteAcceptedAmountDate |
|
DATETIME |
YES |
|
| PromNoteDirectLoanIdentifier |
|
CHAR(21) |
YES |
|
| PromNoteAcceptedSequenceNumber |
|
INTEGER |
YES |
|
| PromNoteAcknowledgeBatchIdentifier |
|
CHAR(23) |
YES |
|
| PromNoteAcknowledgeDate |
|
DATETIME |
YES |
|
| IsPromNoteIncludedOnManifest |
|
BIT |
NO |
|
| ManifestBatchIdentifier |
|
CHAR(23) |
YES |
|
| PromNoteManifestDate |
|
DATETIME |
YES |
|
| pluscreditdecisionstatus |
|
CHAR(1) |
YES |
|
| pluscreditdecisiondate |
|
DATETIME |
YES |
|
| studentssn |
|
CHAR(11) |
YES |
|
| studentfirstname |
|
CHAR(9) |
YES |
|
| studentlastname |
|
CHAR(16) |
YES |
|
| studentmi |
|
CHAR(1) |
YES |
|
| studentcitizenstatus |
|
CHAR(1) |
YES |
|
| StudentAlienIdentifier |
|
CHAR(9) |
YES |
|
| StudentBirthDate |
|
DATETIME |
YES |
|
| studentyearincollege |
|
CHAR(2) |
YES |
|
| studentdefaultonloans |
|
CHAR(1) |
YES |
|
| addresschangedate |
|
DATETIME |
YES |
|
| localaddresschangedate |
|
DATETIME |
YES |
|
| ssnchangedate |
|
DATETIME |
YES |
|
| BirthDateChangeDate |
|
DATETIME |
YES |
|
| LastModifiedUserId |
|
INTEGER |
NO |
|
| CreatedDateTime |
|
DATETIME |
NO |
|
| LastModifiedDateTime |
|
DATETIME |
NO |
|
| RowVersion |
|
TIMESTAMP/DATE |
NO |
|
| AltBorrowerStudentLoanDebt |
|
MONEY(19, 4) |
YES |
|
| borrowerInterestIndicator |
|
CHAR(1) |
YES |
|
| BorrowerLegalResidenceState |
|
CHAR(2) |
YES |
|
| BorrowerLegalResidenceStateDate |
|
DATETIME |
YES |
|
| borrowerOutstandingLoans |
|
CHAR(1) |
YES |
|
| borrowerReferenceCode |
|
CHAR(1) |
YES |
|
| CommonLineApplicationStatus |
|
CHAR(1) |
YES |
|
| CommonLineLoanIdentifier |
|
CHAR(17) |
YES |
|
| DeferRequestCode |
|
CHAR(1) |
YES |
|
| EFTAuthorization |
|
CHAR(1) |
YES |
|
| CommonLineRecipientLendingInstitutionId |
|
INTEGER |
YES |
|
| LoanAmountCertified |
|
MONEY(19, 4) |
YES |
|
| ProcessingCode |
|
CHAR(2) |
YES |
|
| PromNoteDeliveryCode |
|
CHAR(1) |
YES |
|
| RecordTypeIndicatorCode |
|
CHAR(1) |
YES |
|
| SerialLoanCode |
|
CHAR(1) |
YES |
|
| StudentSignatureCode |
|
CHAR(1) |
YES |
|
| DisclosurePrintedDate |
|
DATETIME |
YES |
|
| OriginationFeePercentage |
|
MONEY(19, 4) |
NO |
|
| IsDisclosurePrintedAtLoc |
|
BIT |
NO |
|
| CommonLineApplicationStatusDate |
|
DATETIME |
YES |
|
| CommonLineApplicationLoanPhase |
|
CHAR(4) |
YES |
|
| CommonLineApplicationLoanPhaseDate |
|
DATETIME |
YES |
|
| CommonLineLoanSequenceNumber |
|
CHAR(2) |
YES |
|
| GuaranteeReductionCode |
|
CHAR(2) |
YES |
|
| LoanAmountCertifiedDate |
|
DATETIME |
YES |
|
| LoanAmountGuaranteed |
|
MONEY(19, 4) |
YES |
|
| LoanGuaranteeDate |
|
DATETIME |
YES |
|
| EmailAddress |
|
VARCHAR(50) |
YES |
|
| InterestRebatePercentage |
|
MONEY(19, 4) |
YES |
|
| MasterPromNoteIndicator |
|
CHAR(1) |
YES |
|
| LastPaymentDate |
|
DATETIME |
YES |
|
| DeliquentDate |
|
DATETIME |
YES |
|
| ExpirationDate |
|
DATETIME |
YES |
|
| GraceDays |
|
NUMERIC(9, 0) |
YES |
|
| LoanStatusEffectiveDate |
|
DATETIME |
YES |
|
| LoanStatusCodeId |
|
INTEGER |
YES |
|
| LoanBalance |
|
MONEY(19, 4) |
YES |
|
| LoanInterest |
|
NUMERIC(9, 2) |
YES |
|
| NumberPayments |
|
NUMERIC(9, 0) |
YES |
|
| PaymentAmount |
|
MONEY(19, 4) |
YES |
|
| PreClaimsDate |
|
DATETIME |
YES |
|
| RepaymentDate |
|
DATETIME |
YES |
|
| MasterPromNoteType |
|
CHAR(1) |
YES |
|
| OriginationRejectCodes |
|
CHAR(75) |
YES |
|
| EndorserAmount |
|
MONEY(19, 4) |
NO |
|
| BorrowerIdentifier |
|
VARCHAR(44) |
YES |
|
| IsIdentifierChanged |
|
BIT |
NO |
|
| PrintDisclosureCode |
|
CHAR(1) |
YES |
|
| BorrowerStreetAddress |
|
VARCHAR(2000) |
YES |
|
| DefaultDate |
|
DATETIME |
YES |
|
DefaultRateUsageCodeId |
|
INTEGER |
YES |
|
| IsPreProfessionalCourseWork |
|
BIT |
NO |
|
| MasterPromNoteExpirationDate |
|
DATETIME |
YES |
|
| IsEntranceCounselingReceived |
|
BIT |
NO |
|
| LoanCreateDate |
|
DATETIME |
YES |
|
| ApplicationIdentifier |
|
CHAR(10) |
YES |
|
| ApplicationCompleteDate |
|
DATETIME |
YES |
|
| ApplicationLoanAmount |
|
NUMERIC(11, 2) |
YES |
|
| CreditBalanceOption |
|
CHAR(1) |
YES |
|
| CreditActionChoice |
|
CHAR(1) |
YES |
|
| CreditAppealStatus |
|
CHAR(1) |
YES |
|
| MaximumLoanIndicator |
|
CHAR(1) |
YES |
|
| CreditDecisionExpirationDate |
|
DATETIME |
YES |
|
| OriginalCreditDecisionStatus |
|
CHAR(1) |
YES |
|
| IsDefermentOption |
|
BIT |
YES |
|
| IsParentRejectedForPlus |
|
BIT |
NO |
|
| SpecialProgramType |
|
CHAR(1) |
NO |
|
| Key Name |
Key Type |
Keys |
| FaLoan_OriginationBatchID_N_N_IDX |
Inversion Entry |
OriginationBatchIdentifier |
| FaLoan_faloanid_U_C_IDX |
PrimaryKey |
Id |
| FaLoan_FaStudentAidID_CLApplicationStatus_ProcessingCode_FaLoanID_U_N_IDX |
Alternate Key |
StudentAwardId, CommonLineApplicationStatus, ProcessingCode, Id |
| FaLoan_DirectLoanID_N_N_IDX |
Inversion Entry |
DirectLoanIdentifier |
| FaLoan_CommonLineLoanID_N_N_IDX |
Inversion Entry |
CommonLineLoanIdentifier |
| FaLoan_fastudentaidid_N_N_IDX |
Inversion Entry |
StudentAwardId |
| Nk_FaLoan_FaLoanId_FaStudentAidId_LoanAmoutCertified |
Inversion Entry |
Id, StudentAwardId, LoanAmountCertified |
| Nk_FaLoan_CLApplicationStatus_ProcessingCode_FaStudentAidID |
Inversion Entry |
CommonLineApplicationStatus, ProcessingCode, StudentAwardId |